The following steps summarize a typical Oracle Data Service Integrator-based project development cycle.
Create your project. Create a Oracle Data Service Integrator-based project in a new or existing Workshop for WebLogic application.
Create physical data services. Metadata representing physical data sources can be obtained for any data source that is available through your local application or Oracle WebLogic Server. This may include relational data, Web service data, delimited files (spreadsheet data), custom Java functions, and XML files.
Create a data model. You can optionally build a data model that shows the relationships and cardinality between the data services you have selected (see Modeling Data Services for details). Through the data model, you can also modify and extend relationships between various data services as well as their return type.
Develop data services. You can elaborate on existing physical data through queries that span multiple physical and/or logical data services. The built-in Query editor ncludes standard XQuery functions and language construct prototypes. Using the editor you can map source elements or transformations to a return type. Queries and data service logic are maintained in a single, editable source file that is fully integrated with your data service (Working with XQuery Source).
Test your function. You can select any query in the current data service, add a simple or complex parameter (if required), run the query, and see the results. You can also update source data through Test View and create ad hoc queries and procedures.
Review your query plan. You can view the query plan prior to or after running your query. The query plan describes the generated statements used to retrieve and update data. Execution time statistics are also available.
Document generated by Confluence on Jan 13, 2009 15:57